
USE [bmig_Mensual_Post_cadena]
GO

IF EXISTS (SELECT name FROM   sysobjects WHERE  name = 'WASP_M0011_CREATBL_CodSegSalud' AND type = 'P')
    DROP PROCEDURE [dbo].[WASP_M0011_CREATBL_CodSegSalud]
GO

CREATE PROCEDURE [dbo].[WASP_M0011_CREATBL_CodSegSalud]

AS

BEGIN

		if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[codsegSalud]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		drop table [dbo].[codsegSalud]
		
		CREATE TABLE [dbo].[codsegSalud] (
			[ppsuc]		[int] NOT NULL ,
			[ppcta]		[int] NOT NULL ,
			[ppoper]	[int] NOT NULL ,
			[ppimp11]	[decimal](17, 2) NULL ,
			[ppimp12]	[decimal](17, 2) NULL ,
			[ppimp13]	[decimal](17, 2) NULL ,
			[ppimp14]	[decimal](17, 2) NULL ,
			[ppimp15]	[decimal](17, 2) NULL ,
			[ppimp16]	[decimal](17, 2) NULL ,
			[ppimp17]	[decimal](17, 2) NULL ,
			[ppimp18]	[decimal](17, 2) NULL ,
			[ppimp19]	[decimal](17, 2) NULL 
		) ON [PRIMARY]
		
END